Skip Headers

Oracle® Database SQL Reference 10g Release 2 (10.2) Part Number B14200-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# UPPER

Syntax

Description of the illustration upper.gif

Purpose

`UPPER` returns `char`, with all letters uppercase. `char` can be any of the datatypes `CHAR`, `VARCHAR2`, `NCHAR`, `NVARCHAR2`, `CLOB`, or `NCLOB`. The return value is the same datatype as `char`. The database sets the case of the characters based on the binary mapping defined for the underlying character set. For linguistic-sensitive uppercase, please refer to NLS_UPPER.

Examples

The following example returns each employee's last name in uppercase:

    SELECT UPPER(last_name) "Uppercase"
       FROM employees;